﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace OnlineManagement.Common
{
   public class PubProcedures
   {
       /// <summary>
       /// 注册hoggery存储过程
       /// </summary>
       public static  readonly string RegistHoggeryProce="RegistHoggery_Proce";

       /// <summary>
       /// 猪场中猪的生产日志
       /// </summary>
       public static readonly string PigMgrLogProc = "PigMgrLog_Proc";

       /// <summary>
       /// 分页获取pigPen 存储过程
       /// </summary>
       public static readonly string PigPensByPagingProce = "PigPensByPaging_Proce";
       public static readonly string PigPenDeleteProce = "PigPenDelete_Proce";

       #region sow proces
       public static readonly string SowAddproc = "SowAdd_proc";
       public static readonly string SowDeletedProce = "SowDeleted_proce";
       /// <summary>
       /// SowUpdate_Proce
       /// </summary>
       public static readonly string SowUpdateProce = "SowUpdate_Proce";

       /// <summary>
       /// procedure name of GetSowsByHoggeryID
       /// </summary>
       public static readonly string GetSowsByHoggeryIDProce = "GetSowsByHoggeryID";

       /// <summary>
       /// GetSowSettingsInfo_Proce
       /// </summary>
       public static readonly string GetSowSettingsInfoProce = "GetSowSettingsInfo_Proce";
       /// <summary>
       /// sow data paging proce
       /// </summary>
       public static readonly string GetSowsByPageProce = "GetSowsByPage_Proce";
       /// <summary>
       /// get sow basic infomation for every sow operation
       /// BitID,CustomizeID,TypeName
       /// </summary>
       public static readonly string GetSowBasicInfo = "GetSowBasicInfo_Proce";


      
       #endregion

       #region 母猪发情存储过程
        public static readonly string SowFaQingRecordAddProce = "SowFaQingRecordAdd_Proce";
       #endregion

       #region  母猪繁殖 SowPropagate procs
       /// <summary>
       /// 母猪繁殖，获取分娩期母猪信息，繁殖母猪耳号信息
       /// </summary>
       public static readonly string GetPropagateSowProc = "GetPropagateSow_Proc";

       /// <summary>
       /// 繁殖存储过程名字 SowPropagateProce
       /// </summary>
       public static readonly string SowPropagateProce = "SowPropagate_Proce";
       /// <summary>
       /// 添加母猪分娩/繁殖记录
       /// </summary>
       public static readonly string SowPropagateRecordAddProce = "SowPropagateRecordAdd_Proce";
       #endregion




       #region 母猪配种 HybridizationRecord proces
       /// <summary>
       /// 母猪配种，获取空怀期母猪信息
       /// </summary>
        public static readonly string GetHybridizationSowProc = "GetHybridizationSow_Proc";

       /// <summary>
        /// Get Hybridization sow basic information, such as pigpenName,feedername and pigTypeName
       /// </summary>
        public static readonly string GetHybridizationSowBasicInfo_Proc = "GetHybridizationSowBasicInfo_Proc";

       /// <summary>
       /// 次存储过程不再使用
       /// </summary>
        public static readonly string SowHybridizationRecordAddProce = "SowHybridizationRecordAdd_Proce";

        public static readonly string SowMultipileHybridizationRecordAddProce = "SowMultipileHybridizationRecordAdd_Proce";

       /// <summary>
       /// 获取指定母猪配种信息
       /// </summary>
        public static readonly string GetSowSpecificHybrizationProce = "GetSowSpecificHybrization_Proce";
       #endregion

        #region 母猪反情检查存储过程
           /// <summary>
           /// 母猪反情检查存储过程
           /// </summary>
        public static readonly string SowFanQingValidateProce = "SowFanQingValidate_Proce";
        #endregion

        #region 母猪妊娠检查之流产
       /// <summary>
        /// 母猪妊娠检查之流产
       /// </summary>
        public static readonly string SowAbortionProce = "SowAbortion_Proce";
        #endregion

        #region 母猪断奶登记
        public static string SowWeanedRecordAdd = "SowWeanedRecord_Add";
        #endregion
        #region 母猪
        #endregion
        #region PigPen Procs
        /// <summary>
       ///猪舍添加存储过程 PigPenAdd_proce
       /// </summary>
       public static readonly string PigPenAddproce = "PigPenAdd_proce";

       /// <summary>
       ///get all pigpens-- GetAllPigPens_Proce
       /// </summary>
       public static readonly string GetAllPigPensProce = "GetAllPigPens_Proce";
       #endregion

       #region hoggery pigs Purchase procs
       public static readonly string GetPigletsByHoggeryIDProce = "GetPigletsByHoggeryID_Proce";

       /// <summary>
       /// pigs grow phase changes procudure,包括hog 和piglets成长阶段的改变
       /// </summary>
       public static readonly string HogsGrowPhaseChangedProce = "HogsGrowPhaseChanged_Proce";

       /// <summary>
       /// 根据购买的猪的类型获得相关的页面初始信息的存储过程名称
       /// </summary>
       public static readonly string GetHogInfoForPurchaseProce = "GetHogInfoForPurchase_Proce";

       public static readonly string HogPurchaseProce = "HogPurchase_Proce";
       #endregion
   }
}
